USE [LAFDC]
GO
/****** Object:  Table [dbo].[Personne]    Script Date: 11/23/2009 22:56:05 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Personne](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[prev_id] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[nom] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[prenom] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[civ-sexe] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[sfam] [varchar](32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[anniv] [varchar](10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[created] [datetime] NULL,
	[last_modified] [datetime] NULL,
 CONSTRAINT [PK_Personne] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF